The ESI Posted Transaction between Dates function creates the export file of the detail transactions in the accounting ledger by transaction date – regardless of the accounting period in which the transaction was posted.
1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.
2. At the Start Date field enter the start date for the ESI Transactions between Dates file.
3. At the End Date field enter the end date for the ESI Transactions between Dates file.
4. The following message will display: "Print report? No/Yes."
5. The following message will appear: "Create a delimited ASC file? No/Yes."
Make the appropriate selection.
Two DBF files will be created, PDMMDDYYYY.dbf and PD_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The PDMMDDYYYY.dbf file is the ESI Posted Transaction between dates file for the date range entered with MMDDYYYY equal to the ending date selected The PD_Last.dbf is a copy of the current file. If an ASC file was created, the name will be PDMMDDYYYY.asc and will be in the Shared \NetYield\Data\Company Name\ESI Outbox folder.
The following fields will print on the report:
The following fields will be exported from the system:
| Field Name | Description | Type |
| LICNUMBER | The Net•Yield license number | C 4 |
| PERIOD | The accounting period | C 2 |
| YEAR | The accounting year | C 4 |
| JOURNAL | The journal entry type – see Post Batches for more information. | C 2 |
| SOURCE | The journal entry transaction type – see Post Batches for more information. | C 2 |
| ACCOUNT | The account number | C 4 |
| SUB_ACCT | The cost center | C 6 |
| CRS_ACCT | C 6 | |
| REFERENCE | The transaction reference number | C 6 |
| AMOUNT | The amount of the journal entry | N 12, 2 |
| CR_DB | The credit or debit for the journal entry | C 1 |
| DATE | The date of the transaction | D 8 |
| DESC | The transaction description | C 30 |
Security Required : Ledger - Ledger Reports
| See Also |